SELECT *, CASE WHEN `name` LIKE "east meadow%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "east meadow" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "east meadow" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "east meadow" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("east meadow") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$1,499,0002341 7th StEast Meadow NY 11554View Listing
$1,499,0001807 Casper AveEast Meadow NY 11554View Listing
$1,499,0001630 Noble StEast Meadow NY 11554View Listing
$1,480,0002082 Stuyvesant AveEast Meadow NY 11554View Listing
$1,399,000542 Tremont PlEast Meadow NY 11554View Listing
$1,349,0002328 Hudson StEast Meadow NY 11554View Listing
$1,349,000718 Merrick AveEast Meadow NY 11554View Listing
$1,338,0002476 Cypress AveEast Meadow NY 11554View Listing
$1,268,0001634 Carla LnEast Meadow NY 11554View Listing
$999,0001435 Sherwood DrEast Meadow NY 11554View Listing
$959,0002382 Jefferson StEast Meadow NY 11554View Listing
$919,9992509 4th AveEast Meadow NY 11554View Listing
$899,000308 Clearmeadow DrEast Meadow NY 11554View Listing
$879,000384 Berg AveEast Meadow NY 11554View Listing
$878,8882175 Clover CtEast Meadow NY 11554View Listing
$850,0002497 Cypress AveEast Meadow NY 11554View Listing
$849,0001389 Apple LnEast Meadow NY 11554View Listing
$825,0002429 York StEast Meadow NY 11554View Listing
$799,00043 Taylor AveEast Meadow NY 11554View Listing
$779,9992620 Lexington AveEast Meadow NY 11554View Listing
$750,000300 Peters AveEast Meadow NY 11554View Listing
$749,999820 Van Buren AveEast Meadow NY 11554View Listing
$749,9992216 5th StEast Meadow NY 11554View Listing
$749,000610 Irving PlEast Meadow NY 11554View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 9:18:24 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah